package com.shzu.jwc.ty.bean;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class PeTestExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public PeTestExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andPeTestIdIsNull() {
            addCriterion("pe_test_id is null");
            return (Criteria) this;
        }

        public Criteria andPeTestIdIsNotNull() {
            addCriterion("pe_test_id is not null");
            return (Criteria) this;
        }

        public Criteria andPeTestIdEqualTo(Integer value) {
            addCriterion("pe_test_id =", value, "peTestId");
            return (Criteria) this;
        }

        public Criteria andPeTestIdNotEqualTo(Integer value) {
            addCriterion("pe_test_id <>", value, "peTestId");
            return (Criteria) this;
        }

        public Criteria andPeTestIdGreaterThan(Integer value) {
            addCriterion("pe_test_id >", value, "peTestId");
            return (Criteria) this;
        }

        public Criteria andPeTestIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("pe_test_id >=", value, "peTestId");
            return (Criteria) this;
        }

        public Criteria andPeTestIdLessThan(Integer value) {
            addCriterion("pe_test_id <", value, "peTestId");
            return (Criteria) this;
        }

        public Criteria andPeTestIdLessThanOrEqualTo(Integer value) {
            addCriterion("pe_test_id <=", value, "peTestId");
            return (Criteria) this;
        }

        public Criteria andPeTestIdIn(List<Integer> values) {
            addCriterion("pe_test_id in", values, "peTestId");
            return (Criteria) this;
        }

        public Criteria andPeTestIdNotIn(List<Integer> values) {
            addCriterion("pe_test_id not in", values, "peTestId");
            return (Criteria) this;
        }

        public Criteria andPeTestIdBetween(Integer value1, Integer value2) {
            addCriterion("pe_test_id between", value1, value2, "peTestId");
            return (Criteria) this;
        }

        public Criteria andPeTestIdNotBetween(Integer value1, Integer value2) {
            addCriterion("pe_test_id not between", value1, value2, "peTestId");
            return (Criteria) this;
        }

        public Criteria andPeTestNameIsNull() {
            addCriterion("pe_test_name is null");
            return (Criteria) this;
        }

        public Criteria andPeTestNameIsNotNull() {
            addCriterion("pe_test_name is not null");
            return (Criteria) this;
        }

        public Criteria andPeTestNameEqualTo(String value) {
            addCriterion("pe_test_name =", value, "peTestName");
            return (Criteria) this;
        }

        public Criteria andPeTestNameNotEqualTo(String value) {
            addCriterion("pe_test_name <>", value, "peTestName");
            return (Criteria) this;
        }

        public Criteria andPeTestNameGreaterThan(String value) {
            addCriterion("pe_test_name >", value, "peTestName");
            return (Criteria) this;
        }

        public Criteria andPeTestNameGreaterThanOrEqualTo(String value) {
            addCriterion("pe_test_name >=", value, "peTestName");
            return (Criteria) this;
        }

        public Criteria andPeTestNameLessThan(String value) {
            addCriterion("pe_test_name <", value, "peTestName");
            return (Criteria) this;
        }

        public Criteria andPeTestNameLessThanOrEqualTo(String value) {
            addCriterion("pe_test_name <=", value, "peTestName");
            return (Criteria) this;
        }

        public Criteria andPeTestNameLike(String value) {
            addCriterion("pe_test_name like", value, "peTestName");
            return (Criteria) this;
        }

        public Criteria andPeTestNameNotLike(String value) {
            addCriterion("pe_test_name not like", value, "peTestName");
            return (Criteria) this;
        }

        public Criteria andPeTestNameIn(List<String> values) {
            addCriterion("pe_test_name in", values, "peTestName");
            return (Criteria) this;
        }

        public Criteria andPeTestNameNotIn(List<String> values) {
            addCriterion("pe_test_name not in", values, "peTestName");
            return (Criteria) this;
        }

        public Criteria andPeTestNameBetween(String value1, String value2) {
            addCriterion("pe_test_name between", value1, value2, "peTestName");
            return (Criteria) this;
        }

        public Criteria andPeTestNameNotBetween(String value1, String value2) {
            addCriterion("pe_test_name not between", value1, value2, "peTestName");
            return (Criteria) this;
        }

        public Criteria andPeTestStarTimeIsNull() {
            addCriterion("pe_test_star_time is null");
            return (Criteria) this;
        }

        public Criteria andPeTestStarTimeIsNotNull() {
            addCriterion("pe_test_star_time is not null");
            return (Criteria) this;
        }

        public Criteria andPeTestStarTimeEqualTo(Date value) {
            addCriterion("pe_test_star_time =", value, "peTestStarTime");
            return (Criteria) this;
        }

        public Criteria andPeTestStarTimeNotEqualTo(Date value) {
            addCriterion("pe_test_star_time <>", value, "peTestStarTime");
            return (Criteria) this;
        }

        public Criteria andPeTestStarTimeGreaterThan(Date value) {
            addCriterion("pe_test_star_time >", value, "peTestStarTime");
            return (Criteria) this;
        }

        public Criteria andPeTestStarTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("pe_test_star_time >=", value, "peTestStarTime");
            return (Criteria) this;
        }

        public Criteria andPeTestStarTimeLessThan(Date value) {
            addCriterion("pe_test_star_time <", value, "peTestStarTime");
            return (Criteria) this;
        }

        public Criteria andPeTestStarTimeLessThanOrEqualTo(Date value) {
            addCriterion("pe_test_star_time <=", value, "peTestStarTime");
            return (Criteria) this;
        }

        public Criteria andPeTestStarTimeIn(List<Date> values) {
            addCriterion("pe_test_star_time in", values, "peTestStarTime");
            return (Criteria) this;
        }

        public Criteria andPeTestStarTimeNotIn(List<Date> values) {
            addCriterion("pe_test_star_time not in", values, "peTestStarTime");
            return (Criteria) this;
        }

        public Criteria andPeTestStarTimeBetween(Date value1, Date value2) {
            addCriterion("pe_test_star_time between", value1, value2, "peTestStarTime");
            return (Criteria) this;
        }

        public Criteria andPeTestStarTimeNotBetween(Date value1, Date value2) {
            addCriterion("pe_test_star_time not between", value1, value2, "peTestStarTime");
            return (Criteria) this;
        }

        public Criteria andPeTestEndTimeIsNull() {
            addCriterion("pe_test_end_time is null");
            return (Criteria) this;
        }

        public Criteria andPeTestEndTimeIsNotNull() {
            addCriterion("pe_test_end_time is not null");
            return (Criteria) this;
        }

        public Criteria andPeTestEndTimeEqualTo(Date value) {
            addCriterion("pe_test_end_time =", value, "peTestEndTime");
            return (Criteria) this;
        }

        public Criteria andPeTestEndTimeNotEqualTo(Date value) {
            addCriterion("pe_test_end_time <>", value, "peTestEndTime");
            return (Criteria) this;
        }

        public Criteria andPeTestEndTimeGreaterThan(Date value) {
            addCriterion("pe_test_end_time >", value, "peTestEndTime");
            return (Criteria) this;
        }

        public Criteria andPeTestEndTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("pe_test_end_time >=", value, "peTestEndTime");
            return (Criteria) this;
        }

        public Criteria andPeTestEndTimeLessThan(Date value) {
            addCriterion("pe_test_end_time <", value, "peTestEndTime");
            return (Criteria) this;
        }

        public Criteria andPeTestEndTimeLessThanOrEqualTo(Date value) {
            addCriterion("pe_test_end_time <=", value, "peTestEndTime");
            return (Criteria) this;
        }

        public Criteria andPeTestEndTimeIn(List<Date> values) {
            addCriterion("pe_test_end_time in", values, "peTestEndTime");
            return (Criteria) this;
        }

        public Criteria andPeTestEndTimeNotIn(List<Date> values) {
            addCriterion("pe_test_end_time not in", values, "peTestEndTime");
            return (Criteria) this;
        }

        public Criteria andPeTestEndTimeBetween(Date value1, Date value2) {
            addCriterion("pe_test_end_time between", value1, value2, "peTestEndTime");
            return (Criteria) this;
        }

        public Criteria andPeTestEndTimeNotBetween(Date value1, Date value2) {
            addCriterion("pe_test_end_time not between", value1, value2, "peTestEndTime");
            return (Criteria) this;
        }

        public Criteria andPeTestPlaceIsNull() {
            addCriterion("pe_test_place is null");
            return (Criteria) this;
        }

        public Criteria andPeTestPlaceIsNotNull() {
            addCriterion("pe_test_place is not null");
            return (Criteria) this;
        }

        public Criteria andPeTestPlaceEqualTo(String value) {
            addCriterion("pe_test_place =", value, "peTestPlace");
            return (Criteria) this;
        }

        public Criteria andPeTestPlaceNotEqualTo(String value) {
            addCriterion("pe_test_place <>", value, "peTestPlace");
            return (Criteria) this;
        }

        public Criteria andPeTestPlaceGreaterThan(String value) {
            addCriterion("pe_test_place >", value, "peTestPlace");
            return (Criteria) this;
        }

        public Criteria andPeTestPlaceGreaterThanOrEqualTo(String value) {
            addCriterion("pe_test_place >=", value, "peTestPlace");
            return (Criteria) this;
        }

        public Criteria andPeTestPlaceLessThan(String value) {
            addCriterion("pe_test_place <", value, "peTestPlace");
            return (Criteria) this;
        }

        public Criteria andPeTestPlaceLessThanOrEqualTo(String value) {
            addCriterion("pe_test_place <=", value, "peTestPlace");
            return (Criteria) this;
        }

        public Criteria andPeTestPlaceLike(String value) {
            addCriterion("pe_test_place like", value, "peTestPlace");
            return (Criteria) this;
        }

        public Criteria andPeTestPlaceNotLike(String value) {
            addCriterion("pe_test_place not like", value, "peTestPlace");
            return (Criteria) this;
        }

        public Criteria andPeTestPlaceIn(List<String> values) {
            addCriterion("pe_test_place in", values, "peTestPlace");
            return (Criteria) this;
        }

        public Criteria andPeTestPlaceNotIn(List<String> values) {
            addCriterion("pe_test_place not in", values, "peTestPlace");
            return (Criteria) this;
        }

        public Criteria andPeTestPlaceBetween(String value1, String value2) {
            addCriterion("pe_test_place between", value1, value2, "peTestPlace");
            return (Criteria) this;
        }

        public Criteria andPeTestPlaceNotBetween(String value1, String value2) {
            addCriterion("pe_test_place not between", value1, value2, "peTestPlace");
            return (Criteria) this;
        }

        public Criteria andPeTestUpperLimitIsNull() {
            addCriterion("pe_test_upper_limit is null");
            return (Criteria) this;
        }

        public Criteria andPeTestUpperLimitIsNotNull() {
            addCriterion("pe_test_upper_limit is not null");
            return (Criteria) this;
        }

        public Criteria andPeTestUpperLimitEqualTo(Integer value) {
            addCriterion("pe_test_upper_limit =", value, "peTestUpperLimit");
            return (Criteria) this;
        }

        public Criteria andPeTestUpperLimitNotEqualTo(Integer value) {
            addCriterion("pe_test_upper_limit <>", value, "peTestUpperLimit");
            return (Criteria) this;
        }

        public Criteria andPeTestUpperLimitGreaterThan(Integer value) {
            addCriterion("pe_test_upper_limit >", value, "peTestUpperLimit");
            return (Criteria) this;
        }

        public Criteria andPeTestUpperLimitGreaterThanOrEqualTo(Integer value) {
            addCriterion("pe_test_upper_limit >=", value, "peTestUpperLimit");
            return (Criteria) this;
        }

        public Criteria andPeTestUpperLimitLessThan(Integer value) {
            addCriterion("pe_test_upper_limit <", value, "peTestUpperLimit");
            return (Criteria) this;
        }

        public Criteria andPeTestUpperLimitLessThanOrEqualTo(Integer value) {
            addCriterion("pe_test_upper_limit <=", value, "peTestUpperLimit");
            return (Criteria) this;
        }

        public Criteria andPeTestUpperLimitIn(List<Integer> values) {
            addCriterion("pe_test_upper_limit in", values, "peTestUpperLimit");
            return (Criteria) this;
        }

        public Criteria andPeTestUpperLimitNotIn(List<Integer> values) {
            addCriterion("pe_test_upper_limit not in", values, "peTestUpperLimit");
            return (Criteria) this;
        }

        public Criteria andPeTestUpperLimitBetween(Integer value1, Integer value2) {
            addCriterion("pe_test_upper_limit between", value1, value2, "peTestUpperLimit");
            return (Criteria) this;
        }

        public Criteria andPeTestUpperLimitNotBetween(Integer value1, Integer value2) {
            addCriterion("pe_test_upper_limit not between", value1, value2, "peTestUpperLimit");
            return (Criteria) this;
        }

        public Criteria andPeTestLowerLimitIsNull() {
            addCriterion("pe_test_lower_limit is null");
            return (Criteria) this;
        }

        public Criteria andPeTestLowerLimitIsNotNull() {
            addCriterion("pe_test_lower_limit is not null");
            return (Criteria) this;
        }

        public Criteria andPeTestLowerLimitEqualTo(Integer value) {
            addCriterion("pe_test_lower_limit =", value, "peTestLowerLimit");
            return (Criteria) this;
        }

        public Criteria andPeTestLowerLimitNotEqualTo(Integer value) {
            addCriterion("pe_test_lower_limit <>", value, "peTestLowerLimit");
            return (Criteria) this;
        }

        public Criteria andPeTestLowerLimitGreaterThan(Integer value) {
            addCriterion("pe_test_lower_limit >", value, "peTestLowerLimit");
            return (Criteria) this;
        }

        public Criteria andPeTestLowerLimitGreaterThanOrEqualTo(Integer value) {
            addCriterion("pe_test_lower_limit >=", value, "peTestLowerLimit");
            return (Criteria) this;
        }

        public Criteria andPeTestLowerLimitLessThan(Integer value) {
            addCriterion("pe_test_lower_limit <", value, "peTestLowerLimit");
            return (Criteria) this;
        }

        public Criteria andPeTestLowerLimitLessThanOrEqualTo(Integer value) {
            addCriterion("pe_test_lower_limit <=", value, "peTestLowerLimit");
            return (Criteria) this;
        }

        public Criteria andPeTestLowerLimitIn(List<Integer> values) {
            addCriterion("pe_test_lower_limit in", values, "peTestLowerLimit");
            return (Criteria) this;
        }

        public Criteria andPeTestLowerLimitNotIn(List<Integer> values) {
            addCriterion("pe_test_lower_limit not in", values, "peTestLowerLimit");
            return (Criteria) this;
        }

        public Criteria andPeTestLowerLimitBetween(Integer value1, Integer value2) {
            addCriterion("pe_test_lower_limit between", value1, value2, "peTestLowerLimit");
            return (Criteria) this;
        }

        public Criteria andPeTestLowerLimitNotBetween(Integer value1, Integer value2) {
            addCriterion("pe_test_lower_limit not between", value1, value2, "peTestLowerLimit");
            return (Criteria) this;
        }

        public Criteria andPeTestAskIsNull() {
            addCriterion("pe_test_ask is null");
            return (Criteria) this;
        }

        public Criteria andPeTestAskIsNotNull() {
            addCriterion("pe_test_ask is not null");
            return (Criteria) this;
        }

        public Criteria andPeTestAskEqualTo(String value) {
            addCriterion("pe_test_ask =", value, "peTestAsk");
            return (Criteria) this;
        }

        public Criteria andPeTestAskNotEqualTo(String value) {
            addCriterion("pe_test_ask <>", value, "peTestAsk");
            return (Criteria) this;
        }

        public Criteria andPeTestAskGreaterThan(String value) {
            addCriterion("pe_test_ask >", value, "peTestAsk");
            return (Criteria) this;
        }

        public Criteria andPeTestAskGreaterThanOrEqualTo(String value) {
            addCriterion("pe_test_ask >=", value, "peTestAsk");
            return (Criteria) this;
        }

        public Criteria andPeTestAskLessThan(String value) {
            addCriterion("pe_test_ask <", value, "peTestAsk");
            return (Criteria) this;
        }

        public Criteria andPeTestAskLessThanOrEqualTo(String value) {
            addCriterion("pe_test_ask <=", value, "peTestAsk");
            return (Criteria) this;
        }

        public Criteria andPeTestAskLike(String value) {
            addCriterion("pe_test_ask like", value, "peTestAsk");
            return (Criteria) this;
        }

        public Criteria andPeTestAskNotLike(String value) {
            addCriterion("pe_test_ask not like", value, "peTestAsk");
            return (Criteria) this;
        }

        public Criteria andPeTestAskIn(List<String> values) {
            addCriterion("pe_test_ask in", values, "peTestAsk");
            return (Criteria) this;
        }

        public Criteria andPeTestAskNotIn(List<String> values) {
            addCriterion("pe_test_ask not in", values, "peTestAsk");
            return (Criteria) this;
        }

        public Criteria andPeTestAskBetween(String value1, String value2) {
            addCriterion("pe_test_ask between", value1, value2, "peTestAsk");
            return (Criteria) this;
        }

        public Criteria andPeTestAskNotBetween(String value1, String value2) {
            addCriterion("pe_test_ask not between", value1, value2, "peTestAsk");
            return (Criteria) this;
        }

        public Criteria andPeTestStateIsNull() {
            addCriterion("pe_test_state is null");
            return (Criteria) this;
        }

        public Criteria andPeTestStateIsNotNull() {
            addCriterion("pe_test_state is not null");
            return (Criteria) this;
        }

        public Criteria andPeTestStateEqualTo(Integer value) {
            addCriterion("pe_test_state =", value, "peTestState");
            return (Criteria) this;
        }

        public Criteria andPeTestStateNotEqualTo(Integer value) {
            addCriterion("pe_test_state <>", value, "peTestState");
            return (Criteria) this;
        }

        public Criteria andPeTestStateGreaterThan(Integer value) {
            addCriterion("pe_test_state >", value, "peTestState");
            return (Criteria) this;
        }

        public Criteria andPeTestStateGreaterThanOrEqualTo(Integer value) {
            addCriterion("pe_test_state >=", value, "peTestState");
            return (Criteria) this;
        }

        public Criteria andPeTestStateLessThan(Integer value) {
            addCriterion("pe_test_state <", value, "peTestState");
            return (Criteria) this;
        }

        public Criteria andPeTestStateLessThanOrEqualTo(Integer value) {
            addCriterion("pe_test_state <=", value, "peTestState");
            return (Criteria) this;
        }

        public Criteria andPeTestStateIn(List<Integer> values) {
            addCriterion("pe_test_state in", values, "peTestState");
            return (Criteria) this;
        }

        public Criteria andPeTestStateNotIn(List<Integer> values) {
            addCriterion("pe_test_state not in", values, "peTestState");
            return (Criteria) this;
        }

        public Criteria andPeTestStateBetween(Integer value1, Integer value2) {
            addCriterion("pe_test_state between", value1, value2, "peTestState");
            return (Criteria) this;
        }

        public Criteria andPeTestStateNotBetween(Integer value1, Integer value2) {
            addCriterion("pe_test_state not between", value1, value2, "peTestState");
            return (Criteria) this;
        }

        public Criteria andPeTestAddTimeIsNull() {
            addCriterion("pe_test_add_time is null");
            return (Criteria) this;
        }

        public Criteria andPeTestAddTimeIsNotNull() {
            addCriterion("pe_test_add_time is not null");
            return (Criteria) this;
        }

        public Criteria andPeTestAddTimeEqualTo(Date value) {
            addCriterion("pe_test_add_time =", value, "peTestAddTime");
            return (Criteria) this;
        }

        public Criteria andPeTestAddTimeNotEqualTo(Date value) {
            addCriterion("pe_test_add_time <>", value, "peTestAddTime");
            return (Criteria) this;
        }

        public Criteria andPeTestAddTimeGreaterThan(Date value) {
            addCriterion("pe_test_add_time >", value, "peTestAddTime");
            return (Criteria) this;
        }

        public Criteria andPeTestAddTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("pe_test_add_time >=", value, "peTestAddTime");
            return (Criteria) this;
        }

        public Criteria andPeTestAddTimeLessThan(Date value) {
            addCriterion("pe_test_add_time <", value, "peTestAddTime");
            return (Criteria) this;
        }

        public Criteria andPeTestAddTimeLessThanOrEqualTo(Date value) {
            addCriterion("pe_test_add_time <=", value, "peTestAddTime");
            return (Criteria) this;
        }

        public Criteria andPeTestAddTimeIn(List<Date> values) {
            addCriterion("pe_test_add_time in", values, "peTestAddTime");
            return (Criteria) this;
        }

        public Criteria andPeTestAddTimeNotIn(List<Date> values) {
            addCriterion("pe_test_add_time not in", values, "peTestAddTime");
            return (Criteria) this;
        }

        public Criteria andPeTestAddTimeBetween(Date value1, Date value2) {
            addCriterion("pe_test_add_time between", value1, value2, "peTestAddTime");
            return (Criteria) this;
        }

        public Criteria andPeTestAddTimeNotBetween(Date value1, Date value2) {
            addCriterion("pe_test_add_time not between", value1, value2, "peTestAddTime");
            return (Criteria) this;
        }

        public Criteria andSystemYearIdIsNull() {
            addCriterion("system_year_id is null");
            return (Criteria) this;
        }

        public Criteria andSystemYearIdIsNotNull() {
            addCriterion("system_year_id is not null");
            return (Criteria) this;
        }

        public Criteria andSystemYearIdEqualTo(Integer value) {
            addCriterion("system_year_id =", value, "systemYearId");
            return (Criteria) this;
        }

        public Criteria andSystemYearIdNotEqualTo(Integer value) {
            addCriterion("system_year_id <>", value, "systemYearId");
            return (Criteria) this;
        }

        public Criteria andSystemYearIdGreaterThan(Integer value) {
            addCriterion("system_year_id >", value, "systemYearId");
            return (Criteria) this;
        }

        public Criteria andSystemYearIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("system_year_id >=", value, "systemYearId");
            return (Criteria) this;
        }

        public Criteria andSystemYearIdLessThan(Integer value) {
            addCriterion("system_year_id <", value, "systemYearId");
            return (Criteria) this;
        }

        public Criteria andSystemYearIdLessThanOrEqualTo(Integer value) {
            addCriterion("system_year_id <=", value, "systemYearId");
            return (Criteria) this;
        }

        public Criteria andSystemYearIdIn(List<Integer> values) {
            addCriterion("system_year_id in", values, "systemYearId");
            return (Criteria) this;
        }

        public Criteria andSystemYearIdNotIn(List<Integer> values) {
            addCriterion("system_year_id not in", values, "systemYearId");
            return (Criteria) this;
        }

        public Criteria andSystemYearIdBetween(Integer value1, Integer value2) {
            addCriterion("system_year_id between", value1, value2, "systemYearId");
            return (Criteria) this;
        }

        public Criteria andSystemYearIdNotBetween(Integer value1, Integer value2) {
            addCriterion("system_year_id not between", value1, value2, "systemYearId");
            return (Criteria) this;
        }

        public Criteria andOrderStartTimeIsNull() {
            addCriterion("order_start_time is null");
            return (Criteria) this;
        }

        public Criteria andOrderStartTimeIsNotNull() {
            addCriterion("order_start_time is not null");
            return (Criteria) this;
        }

        public Criteria andOrderStartTimeEqualTo(Date value) {
            addCriterion("order_start_time =", value, "orderStartTime");
            return (Criteria) this;
        }

        public Criteria andOrderStartTimeNotEqualTo(Date value) {
            addCriterion("order_start_time <>", value, "orderStartTime");
            return (Criteria) this;
        }

        public Criteria andOrderStartTimeGreaterThan(Date value) {
            addCriterion("order_start_time >", value, "orderStartTime");
            return (Criteria) this;
        }

        public Criteria andOrderStartTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("order_start_time >=", value, "orderStartTime");
            return (Criteria) this;
        }

        public Criteria andOrderStartTimeLessThan(Date value) {
            addCriterion("order_start_time <", value, "orderStartTime");
            return (Criteria) this;
        }

        public Criteria andOrderStartTimeLessThanOrEqualTo(Date value) {
            addCriterion("order_start_time <=", value, "orderStartTime");
            return (Criteria) this;
        }

        public Criteria andOrderStartTimeIn(List<Date> values) {
            addCriterion("order_start_time in", values, "orderStartTime");
            return (Criteria) this;
        }

        public Criteria andOrderStartTimeNotIn(List<Date> values) {
            addCriterion("order_start_time not in", values, "orderStartTime");
            return (Criteria) this;
        }

        public Criteria andOrderStartTimeBetween(Date value1, Date value2) {
            addCriterion("order_start_time between", value1, value2, "orderStartTime");
            return (Criteria) this;
        }

        public Criteria andOrderStartTimeNotBetween(Date value1, Date value2) {
            addCriterion("order_start_time not between", value1, value2, "orderStartTime");
            return (Criteria) this;
        }

        public Criteria andOrderEndTimeIsNull() {
            addCriterion("order_end_time is null");
            return (Criteria) this;
        }

        public Criteria andOrderEndTimeIsNotNull() {
            addCriterion("order_end_time is not null");
            return (Criteria) this;
        }

        public Criteria andOrderEndTimeEqualTo(Date value) {
            addCriterion("order_end_time =", value, "orderEndTime");
            return (Criteria) this;
        }

        public Criteria andOrderEndTimeNotEqualTo(Date value) {
            addCriterion("order_end_time <>", value, "orderEndTime");
            return (Criteria) this;
        }

        public Criteria andOrderEndTimeGreaterThan(Date value) {
            addCriterion("order_end_time >", value, "orderEndTime");
            return (Criteria) this;
        }

        public Criteria andOrderEndTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("order_end_time >=", value, "orderEndTime");
            return (Criteria) this;
        }

        public Criteria andOrderEndTimeLessThan(Date value) {
            addCriterion("order_end_time <", value, "orderEndTime");
            return (Criteria) this;
        }

        public Criteria andOrderEndTimeLessThanOrEqualTo(Date value) {
            addCriterion("order_end_time <=", value, "orderEndTime");
            return (Criteria) this;
        }

        public Criteria andOrderEndTimeIn(List<Date> values) {
            addCriterion("order_end_time in", values, "orderEndTime");
            return (Criteria) this;
        }

        public Criteria andOrderEndTimeNotIn(List<Date> values) {
            addCriterion("order_end_time not in", values, "orderEndTime");
            return (Criteria) this;
        }

        public Criteria andOrderEndTimeBetween(Date value1, Date value2) {
            addCriterion("order_end_time between", value1, value2, "orderEndTime");
            return (Criteria) this;
        }

        public Criteria andOrderEndTimeNotBetween(Date value1, Date value2) {
            addCriterion("order_end_time not between", value1, value2, "orderEndTime");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}